There are certain restrictions regarding which SQL columns can be indexed. A column can only be indexed if, in its column definition fields:
Its subvalue number (field 7) is 1, (equivalent to 1) or E.
Notes:
Refer to SQL Column and Index Definitions for details of the SQL column definition fields.